/*
 * Copyright (c) 2023-2025 elsfs Authors. All Rights Reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.elsfs.cloud.system.sys.repository.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.elsfs.cloud.module.dict.api.constant.DatasourceNameConstant;
import org.elsfs.cloud.system.api.entity.SysUserPost;

/**
 * 用户职位关系
 *
 * @author zeng
 */
@Mapper
@DS(DatasourceNameConstant.ADMIN)
public interface SysUserPostMapper {
  @Select("select post_id from sys_user_post where user_id = #{userId}")
  List<String> selectPostIdsByUserId(@Param("userId") String userId);

  @Delete("delete from sys_user_post where user_id = #{userId}")
  int deleteByUserId(@Param("userId") String userId);

  @Insert(
      value =
          """
            <script>
            insert into sys_user_post (user_id, post_id)
            values
            <foreach collection="list" item="item" separator=",">
              (#{item.userId},#{item.postId})
            </foreach>
          </script>
          """)
  int insertBatch(@Param("list") List<SysUserPost> userPosts);
}
